select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')

Fitted Organza Appliques Quinces Dresses with Two-toned Ruffles

Nice Two-toned Ruffled Quinceanera Gown Dress with Appliques

Multi-colored Sweetheart Ruffles Sweet Fifteen Dress with Beading

Fashionable Fuchsia Sweetheart Dress for Quince with Embroidery

Multi-tiered Strapless Sweet Sixteen Dress with Beading and Ruches

Yellow and White Quinceanera Party Dresses with Beading Hot Sale

2014 Pick-ups Beaded Sweet 16 Dresses in Apple Green and White

Custom Made White Strapless Sweet 15 Dresses with Embroidery

Red and White Pick-ups Sweet 16 Dresses with Hand Made Flowers

Beaded Sweetheart Dresses for a Quince Pick-ups in Teal and White

Elegant Aqua Blue Pick-ups Dresses for 15 Beading with Bowknot

Purple Organza Ruche Dresses Quinceanera with Appliques Decorate

Fashionable White Sweetheart Ruche Dress for 15 with Embroidery

Dark Green Ruche Sweetheart Taffeta Dress for 15 with Embroidery

Apple Green Strapless Appliques Quince Dress with Ruffled Layers

Light Blue Sweetheart Quinces Dresses with Appliques and Ruffles

Lavender Appliques Organza Quince Dress with Hand Made Flower

Multi-color Ruffled Quinceanera Dresses Sweetheart with Beading

Traditional Sweetheart Ruffled Multi-color Sweet 16 Dress online

Tulle Sweetheart Beaded Multi-color Dresses for Quince on Sale

Brand New Appliqued Halter Top Multi-color Sweet 15 Dresses

Discount V-neck Floor-length Beaded Pink Dress for Sweet 15

Customized one Shoulder Pick Ups Olive Green Dress for Quince

Ball Gown Embroidery Pick Ups Dress for Quince in Royal Blue

2014 Spring Brand New Appliqued Strapless Blue Sweet 15/16 Birthday Dress for survivor

Sweetheart Appliqued Ruffled Medium Slate Blue Sweet 15 Dress

Ball Gown Strapless Embroidery Purple Dresses for a Quince

The Best Strapless Rhinestones Ruffled Colorful Quinceanera Dress for Paris Fashion Week

Off The Shoulder Appliqued Tiered Multi-color Quinceanera Dress

2013 New Arrival Flowers Ruffled Multi-color Sweet 15 Dresses